Business Central API extension, required for PowerCentral solution.

Trial balance and P&L reports by dimensions

Power up your Business Central data with flexible financial reports and advanced financial model:

Free for non-production environments, requires license for PROD. Please request it at sales@nprogression.com.

PowerCentral solution provides you with dashboards and data cube for analysis in Microsoft Excel financial, sales and inventory data of your Microsoft Dynamics 365 Business Central (cloud).

Explore your financial data with predefined dashboards, including:

Financial overview: revenue, cost of goods and services, administrative expenses, profits

Trial balance, Income statement, Balance sheet, Cash Flow statement reports by dimensions
CashFlow forecast analysis

Budget vs actual performance analysis by dimensions

Customer debt analysis by age, currency, and dimensions

Vendor settlements: liabilities analysis by vendors, invoices, age, etc.

Explore your sales and inventory data:

Track Sales budgets vs actual sales

Explore your items sales, find the most profitable and effective segments of your business

Examine your stock, find out what's being stored excessively and what's missing to improve performance

Create as many customized reports and formulas as you wish using Microsoft Excel connection to data, including:

General ledger transactions

General ledger budgets

Customer ledger transactions

Vendor ledger transactions

Item ledger transactions

Sales budgets

Sales invoices and credit memos

The model contains all dimensions you use in BC, multi company support, chart of accounts hierarchy and 20 more most useful attributes.
The measures include Net Change, Balances, Quantities, records count and many other aggregations.
You can Drill into it using dashboards or Excel to get all transactions that summed to the value you explore

To view data with Microsoft Excel pivot tables just install the solution, select “Export” -> “Analyze in excel” and build your own pivot.
Share Excel reports with colleagues

With PowerCentral you can:

Easily analyze your BC data using Microsoft Excel pivots.

Build your own “live” reports with only Excel knowledge.

Do ad-hoc BC data analysis.

Get startup report packs, adjust, customise and them with colleagues.

Do ad-hoc BC data analysis.

Easily see how the figure is calculated, by drilling down and getting transaction level details from Excel.

Installation

You can use PowerCentral for free in non-production BC environments after PowerCentral BC API Extension installation

Production environment requires license

Solution cost

USD 10 per user per month (does not include Power BI license) for standard solution.
Your customized fields and reference data could be added to the model and dashboards by request.
Also you can order customizable and extensible copy of the PowerCentral model

Why N.Progression?

We offer extensive multi-platform expertise in the complete Microsoft Dynamics 365, Power Platform and Azure.

Our deep industry expertise based on 20 years of Microsoft experience and our industry-specific business process modeling and implementation methodology enable faster time to value and lower total cost of ownership.

We offer exclusive add-on products featured on Microsoft AppSource, which help make migration faster and less risk.

PowerCentral API

by Nprogression